Lookup Registry entry

Specify permissions for fields with a Lookup List.

Usage

This Registry entry can be assigned to users and groups:

Key User User Group Group Group Group
Key 1 User User Group Group Group Group
Key 2 user user group group Default Default
Key 3 Table Table Table Table Table Table
Key 4 table Default table Default table Default
Key 5 Lookup
Key 6 column or Default
Value permission

where:

column

is the back-end column name of a Lookup List field; or use Default to apply permission to all Lookup Lists in the table(s) specified in Key 4.

permission

can be:

ReadOnly

Users can only select an existing value from the Lookup List. New values cannot be entered into the field.

A message similar to the following will display if a user tries to save a record with a new value in the Lookup List:

Read Only Lookup List

Skip

An entry will not be checked against the Lookup List and will not be added to the Lookup List.

If the column with Skip enabled is part of a hierarchy, its level of the hierarchy is skipped.

For example: we have a Lookup List called Location with a hierarchy of Country >State >City

If a new entry of Australia > Victoria > Melbourne is added, then three records would typically be added to the Location Lookup List:

Australia

Australia > Victoria

Australia > Victoria > Melbourne

If Skip is enabled for the State column, then entries with Country, State and City will be created, but entries with just Country and State will be skipped. In this example, two records would be created in the Location Lookup List:

Australia

Australia > Victoria > Melbourne

ReadIgnore

If a new value is entered into the field, a warning will display when the record is saved that the Lookup List is ReadOnly. The user has the option to add the value anyway by selecting Ignore; the value is added to the Lookup List but the Hidden flag is set to Yes.

A message similar to the following will display if a user tries to save a record with a new value in the Lookup List:

Read Ignore

Note: The Insert Lookup Show Hidden Registry entry and Query Lookup Show Hidden Registry entry can be used to override this Hidden setting.

ReadWrite

If a new value is entered into the field, the user will be asked to confirm insertion of the value into the Lookup List when the record is saved.

A message similar to the following will display if a user tries to save a record with a new value in the Lookup List:

Read Write

WriteIgnore

When the record is saved, a user will have the option to add (or not to add) a new value to the Lookup List or to select Ignore to add the value and set the Hidden flag to Yes.

A message similar to the following will display if a user tries to save a record with a new value in the Lookup List:

Write Ignore

Note: The Insert Lookup Show Hidden Registry entry and Query Lookup Show Hidden Registry entry can be used to override this Hidden setting.

AutoWrite

A new value will be added to the Lookup List without prompting the user.

AutoWriteIgnore

Combines AutoWrite and WriteIgnore: a new value is automatically added to the Lookup List and the Hidden flag is set to Yes.

Note: The Lookup Registry entry may be set at the field, table, group, or user level, and defaults to ReadWrite.

Note: Read on for details about how Lookup List permissions set in the Registry are processed by lutserver.

Examples

No values may be used that do not already exist in the Lookup List associated with the RecordStatus column in any table:

Key Setting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 Default
Key 5 Lookup
Key 6 RecordStatus
Value ReadOnly

The System default for any Lookup table is ReadWrite unless overwritten by a higher level Registry entry:

Key Setting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 Default
Key 5 Lookup
Key 6 Default
Value ReadWrite

Note: It is possible to make an individual level of a field hierarchy read-only, while the remainder of the levels below it can be updated (read-write). For example, in the Parties module, it is possible to allow users to add new cities but not states / provinces or county names.